<html>
<head>
  <style type="text/css" >
    #fusion{width:400px;}
  </style>
</head>
<body>
<script type="text/javascript">
function getQuerystring(key, default_)
{
  if (default_==null) default_=""; 
  key = key.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
  var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");
  var qs = regex.exec(window.location.href);
  if(qs == null)
    return default_;
  else
    return qs[1];
}
function processData(json){
var htm = '';
var rsProp = {};
  for (var c = 0, col; col=json.table.cols[c]; c++){
    rsProp[col] = c;
    //alert('col c = '+col);
  }
  for (var i = 0, row; row=json.table.rows[i]; i++){
    htm+="<b>Property Id:</b> "+row[rsProp.strPropertyId]+"<br/><b>Price:</b> "+row[rsProp.intPrice]+"<br/><b>Property Type:</b> "+row[rsProp.strPropertyType]+"<br/><b>Location:</b> "+row[rsProp.strLocation_Detail]+"<br/>"+row[rsProp.strDesc]+" <br/><br/>";
  }
 document.getElementById("fusion").innerHTML = htm
}
</script>
<script type="text/javascript">
var qs_os = getQuerystring('os');
var offset = 0;
  if (qs_os > 0){
    offset = qs_os;
  }
script = document.createElement("script")
//script.src = "https://www.google.com/fusiontables/api/query?sql=SELECT+*+FROM+1462263+WHERE+Rubrum+DOES+NOT+CONTAIN+'Beach'+OFFSET+0+LIMIT+1&jsonCallback=processData"; 1583324
//script.src = "https://www.google.com/fusiontables/api/query?sql=SELECT+*+FROM+1462263+OFFSET+2+LIMIT+2&jsonCallback=processData";
//+strPropertyId+,+intPrice+,+strPropertyType+,+strLocation_Detail+,+strDesc+
script.src = "https://www.google.com/fusiontables/api/query?sql=SELECT+ROWID+,+strPropertyId+,+intPrice+,+strPropertyType+,+strLocation_Detail+,+strDesc+FROM+1583324+OFFSET+"+offset+"+LIMIT+12&jsonCallback=processData";

//script.src = "https://www.google.com/fusiontables/api/query?sql=INSERT+INTO+1462263+(Timestamp+,+Ref+,+Price+,+Type+,+Rubrum+,+Location+,+Pool+)+VALUES+ (''+,+'DH4-234VM'+,+250000+,+'Apartment'+,+'Beach,Golf'+,+'Villamartin'+,+'yes'+)&jsonCallback=processData";
//script.src = "https://www.google.com/fusiontables/api/query?sql=SELECT+*+FROM+1583324+OFFSET+150+LIMIT+20&jsonCallback=processData";

document.getElementsByTagName("head")[0].appendChild(script);


</script>
<div id='fusion'></div>
</body>
</html>
